Overview

Brought to you by YData

Dataset statistics

Number of variables43
Number of observations198910
Missing cells2246072
Missing cells (%)26.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory350.2 MiB
Average record size in memory1.8 KiB

Variable types

Text10
Numeric13
Categorical8
DateTime7
Boolean4
Unsupported1

Alerts

Structural Notification has constant value "True"Constant
Voluntary Soft-Story Retrofit has constant value "True"Constant
Fire Only Permit has constant value "True"Constant
Site Permit has constant value "True"Constant
Estimated Cost is highly overall correlated with Revised CostHigh correlation
Existing Construction Type is highly overall correlated with Number of Existing Stories and 2 other fieldsHigh correlation
Existing Construction Type Description is highly overall correlated with Proposed Construction Type and 1 other fieldsHigh correlation
Existing Units is highly overall correlated with Proposed UnitsHigh correlation
Neighborhoods - Analysis Boundaries is highly overall correlated with ZipcodeHigh correlation
Number of Existing Stories is highly overall correlated with Existing Construction Type and 1 other fieldsHigh correlation
Number of Proposed Stories is highly overall correlated with Existing Construction Type and 1 other fieldsHigh correlation
Permit Type is highly overall correlated with Permit Type DefinitionHigh correlation
Permit Type Definition is highly overall correlated with Permit TypeHigh correlation
Plansets is highly overall correlated with Street Number SuffixHigh correlation
Proposed Construction Type is highly overall correlated with Existing Construction Type Description and 1 other fieldsHigh correlation
Proposed Construction Type Description is highly overall correlated with Existing Construction Type Description and 1 other fieldsHigh correlation
Proposed Units is highly overall correlated with Existing UnitsHigh correlation
Revised Cost is highly overall correlated with Estimated CostHigh correlation
Street Number Suffix is highly overall correlated with Existing Construction Type and 1 other fieldsHigh correlation
Zipcode is highly overall correlated with Neighborhoods - Analysis BoundariesHigh correlation
Permit Type Definition is highly imbalanced (83.5%)Imbalance
Street Number Suffix is highly imbalanced (59.2%)Imbalance
Street Suffix is highly imbalanced (69.9%)Imbalance
Current Status is highly imbalanced (60.4%)Imbalance
Existing Construction Type Description is highly imbalanced (60.4%)Imbalance
Street Number Suffix has 196694 (98.9%) missing valuesMissing
Street Suffix has 2768 (1.4%) missing valuesMissing
Unit has 169430 (85.2%) missing valuesMissing
Unit Suffix has 196949 (99.0%) missing valuesMissing
Issued Date has 14942 (7.5%) missing valuesMissing
Completed Date has 101715 (51.1%) missing valuesMissing
First Construction Document Date has 14948 (7.5%) missing valuesMissing
Structural Notification has 191988 (96.5%) missing valuesMissing
Number of Existing Stories has 42788 (21.5%) missing valuesMissing
Number of Proposed Stories has 42871 (21.6%) missing valuesMissing
Voluntary Soft-Story Retrofit has 198875 (> 99.9%) missing valuesMissing
Fire Only Permit has 180082 (90.5%) missing valuesMissing
Permit Expiration Date has 51884 (26.1%) missing valuesMissing
Estimated Cost has 38068 (19.1%) missing valuesMissing
Revised Cost has 6066 (3.0%) missing valuesMissing
Existing Use has 41117 (20.7%) missing valuesMissing
Existing Units has 51543 (25.9%) missing valuesMissing
Proposed Use has 42441 (21.3%) missing valuesMissing
Proposed Units has 50915 (25.6%) missing valuesMissing
Plansets has 37311 (18.8%) missing valuesMissing
TIDF Compliance has 198908 (> 99.9%) missing valuesMissing
Existing Construction Type has 43369 (21.8%) missing valuesMissing
Existing Construction Type Description has 43370 (21.8%) missing valuesMissing
Proposed Construction Type has 43165 (21.7%) missing valuesMissing
Proposed Construction Type Description has 43165 (21.7%) missing valuesMissing
Site Permit has 193550 (97.3%) missing valuesMissing
Estimated Cost is highly skewed (γ1 = 80.2643549)Skewed
Revised Cost is highly skewed (γ1 = 108.7016029)Skewed
Plansets is highly skewed (γ1 = 400.8420748)Skewed
Existing Construction Type is highly skewed (γ1 = 35.25093762)Skewed
Supervisor District is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unit has 21411 (10.8%) zerosZeros
Revised Cost has 8514 (4.3%) zerosZeros
Existing Units has 29135 (14.6%) zerosZeros
Proposed Units has 26885 (13.5%) zerosZeros
Plansets has 63247 (31.8%) zerosZeros

Reproduction

Analysis started2024-08-30 23:21:19.727303
Analysis finished2024-08-30 23:24:01.890480
Duration2 minutes and 42.16 seconds
Software versionydata-profiling vv4.9.0
Download configurationconfig.json

Variables

Distinct181495
Distinct (%)91.2%
Missing0
Missing (%)0.0%
Memory size12.9 MiB
2024-08-30T20:24:02.845610image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.06327
Min length7

Characters and Unicode

Total characters2200595
Distinct characters11
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique167272 ?
Unique (%)84.1%

Sample

1st rowM788927
2nd row201305318356
3rd row201705106205
4th row201410279983
5th row201310280388
ValueCountFrequency (%)
201602179765 101
 
0.1%
201602179758 66
 
< 0.1%
201602179775 30
 
< 0.1%
201708165004 9
 
< 0.1%
201702239990 9
 
< 0.1%
201409166451 9
 
< 0.1%
201707061162 8
 
< 0.1%
201604285989 8
 
< 0.1%
201702099112 8
 
< 0.1%
201602179774 8
 
< 0.1%
Other values (181485) 198654
99.9%
2024-08-30T20:24:04.182166image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 445644
20.3%
1 376248
17.1%
2 338899
15.4%
7 174090
 
7.9%
6 150955
 
6.9%
4 147674
 
6.7%
3 145535
 
6.6%
5 144933
 
6.6%
8 130430
 
5.9%
9 108922
 
4.9%

Most occurring categories

ValueCountFrequency (%)
(unknown) 2200595
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
0 445644
20.3%
1 376248
17.1%
2 338899
15.4%
7 174090
 
7.9%
6 150955
 
6.9%
4 147674
 
6.7%
3 145535
 
6.6%
5 144933
 
6.6%
8 130430
 
5.9%
9 108922
 
4.9%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 2200595
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
0 445644
20.3%
1 376248
17.1%
2 338899
15.4%
7 174090
 
7.9%
6 150955
 
6.9%
4 147674
 
6.7%
3 145535
 
6.6%
5 144933
 
6.6%
8 130430
 
5.9%
9 108922
 
4.9%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 2200595
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
0 445644
20.3%
1 376248
17.1%
2 338899
15.4%
7 174090
 
7.9%
6 150955
 
6.9%
4 147674
 
6.7%
3 145535
 
6.6%
5 144933
 
6.6%
8 130430
 
5.9%
9 108922
 
4.9%

Permit Type
Real number (ℝ)

HIGH CORRELATION 

Distinct8
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7.5222865
Minimum1
Maximum8
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 MiB
2024-08-30T20:24:04.481649image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3
Q18
median8
Q38
95-th percentile8
Maximum8
Range7
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1.457526
Coefficient of variation (CV)0.19376103
Kurtosis6.036264
Mean7.5222865
Median Absolute Deviation (MAD)0
Skewness-2.79896
Sum1496258
Variance2.124382
MonotonicityNot monotonic
2024-08-30T20:24:04.845580image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
8 178852
89.9%
3 14664
 
7.4%
4 2892
 
1.5%
2 950
 
0.5%
6 600
 
0.3%
7 511
 
0.3%
1 350
 
0.2%
5 91
 
< 0.1%
ValueCountFrequency (%)
1 350
 
0.2%
2 950
 
0.5%
3 14664
 
7.4%
4 2892
 
1.5%
5 91
 
< 0.1%
6 600
 
0.3%
7 511
 
0.3%
8 178852
89.9%
ValueCountFrequency (%)
8 178852
89.9%
7 511
 
0.3%
6 600
 
0.3%
5 91
 
< 0.1%
4 2892
 
1.5%
3 14664
 
7.4%
2 950
 
0.5%
1 350
 
0.2%

Permit Type Definition
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct13
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size15.1 MiB
otc alterations permit
178836 
additions alterations or repairs
 
14663
sign - erect
 
2892
new construction wood frame
 
950
demolitions
 
600
Other values (8)
 
969

Length

Max length35
Median length22
Mean length22.572978
Min length11

Characters and Unicode

Total characters4489991
Distinct characters24
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2 ?
Unique (%)< 0.1%

Sample

1st rowotc alterations permit
2nd rowotc alterations permit
3rd rowotc alterations permit
4th rowotc alterations permit
5th rowotc alterations permit

Common Values

ValueCountFrequency (%)
otc alterations permit 178836
89.9%
additions alterations or repairs 14663
 
7.4%
sign - erect 2892
 
1.5%
new construction wood frame 950
 
0.5%
demolitions 600
 
0.3%
wall or painted sign 511
 
0.3%
new construction 347
 
0.2%
grade or quarry or fill or excavate 91
 
< 0.1%
otc alterations permit 8
 
< 0.1%
otc alterations permit # 8
 
< 0.1%
Other values (3) 4
 
< 0.1%

Length

2024-08-30T20:24:05.215923image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
alterations 193516
31.6%
otc 178852
29.2%
permit 178852
29.2%
or 15448
 
2.5%
additions 14664
 
2.4%
repairs 14664
 
2.4%
sign 3403
 
0.6%
2902
 
0.5%
erect 2892
 
0.5%
construction 1300
 
0.2%
Other values (10) 5186
 
0.8%

Most occurring characters

ValueCountFrequency (%)
t 766094
17.1%
i 422865
9.4%
r 422559
9.4%
a 418696
9.3%
412789
9.2%
o 408180
9.1%
e 396450
8.8%
s 228147
 
5.1%
n 216594
 
4.8%
l 195320
 
4.4%
Other values (14) 602297
13.4%

Most occurring categories

ValueCountFrequency (%)
(unknown) 4489991
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
t 766094
17.1%
i 422865
9.4%
r 422559
9.4%
a 418696
9.3%
412789
9.2%
o 408180
9.1%
e 396450
8.8%
s 228147
 
5.1%
n 216594
 
4.8%
l 195320
 
4.4%
Other values (14) 602297
13.4%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 4489991
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
t 766094
17.1%
i 422865
9.4%
r 422559
9.4%
a 418696
9.3%
412789
9.2%
o 408180
9.1%
e 396450
8.8%
s 228147
 
5.1%
n 216594
 
4.8%
l 195320
 
4.4%
Other values (14) 602297
13.4%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 4489991
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
t 766094
17.1%
i 422865
9.4%
r 422559
9.4%
a 418696
9.3%
412789
9.2%
o 408180
9.1%
e 396450
8.8%
s 228147
 
5.1%
n 216594
 
4.8%
l 195320
 
4.4%
Other values (14) 602297
13.4%
Distinct1291
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.5 MiB
Minimum2012-03-28 00:00:00
Maximum2018-02-23 00:00:00
2024-08-30T20:24:05.641686image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:24:06.481384image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Block
Text

Distinct4896
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size11.6 MiB
2024-08-30T20:24:08.129917image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Length

Max length5
Median length4
Mean length4.0363933
Min length3

Characters and Unicode

Total characters802879
Distinct characters19
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique124 ?
Unique (%)0.1%

Sample

1st row0215
2nd row1810
3rd row5700
4th row0661
5th row3642
ValueCountFrequency (%)
3708 1195
 
0.6%
3735 750
 
0.4%
7331 680
 
0.3%
0289 640
 
0.3%
3709 584
 
0.3%
3717 578
 
0.3%
3707 576
 
0.3%
3721 567
 
0.3%
3706 561
 
0.3%
0259 554
 
0.3%
Other values (4886) 192225
96.6%
2024-08-30T20:24:09.681351image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 124327
15.5%
3 97524
12.1%
1 96595
12.0%
2 85374
10.6%
5 80950
10.1%
6 77737
9.7%
7 73548
9.2%
4 60017
7.5%
8 50674
6.3%
9 48902
 
6.1%
Other values (9) 7231
 
0.9%

Most occurring categories

ValueCountFrequency (%)
(unknown) 802879
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
0 124327
15.5%
3 97524
12.1%
1 96595
12.0%
2 85374
10.6%
5 80950
10.1%
6 77737
9.7%
7 73548
9.2%
4 60017
7.5%
8 50674
6.3%
9 48902
 
6.1%
Other values (9) 7231
 
0.9%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 802879
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
0 124327
15.5%
3 97524
12.1%
1 96595
12.0%
2 85374
10.6%
5 80950
10.1%
6 77737
9.7%
7 73548
9.2%
4 60017
7.5%
8 50674
6.3%
9 48902
 
6.1%
Other values (9) 7231
 
0.9%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 802879
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
0 124327
15.5%
3 97524
12.1%
1 96595
12.0%
2 85374
10.6%
5 80950
10.1%
6 77737
9.7%
7 73548
9.2%
4 60017
7.5%
8 50674
6.3%
9 48902
 
6.1%
Other values (9) 7231
 
0.9%

Lot
Text

Distinct1055
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size11.4 MiB
2024-08-30T20:24:10.781320image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Length

Max length4
Median length3
Mean length3.0798753
Min length3

Characters and Unicode

Total characters612618
Distinct characters36
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique180 ?
Unique (%)0.1%

Sample

1st row001
2nd row017A
3rd row027
4th row005
5th row051A
ValueCountFrequency (%)
001 10116
 
5.1%
007 5317
 
2.7%
002 5184
 
2.6%
003 5042
 
2.5%
006 4835
 
2.4%
008 4773
 
2.4%
009 4590
 
2.3%
005 4549
 
2.3%
004 4384
 
2.2%
011 4238
 
2.1%
Other values (1045) 145882
73.3%
2024-08-30T20:24:12.153026image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 266819
43.6%
1 80415
 
13.1%
2 59437
 
9.7%
3 43028
 
7.0%
4 33218
 
5.4%
5 26863
 
4.4%
6 25008
 
4.1%
7 22210
 
3.6%
8 20304
 
3.3%
9 19441
 
3.2%
Other values (26) 15875
 
2.6%

Most occurring categories

ValueCountFrequency (%)
(unknown) 612618
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
0 266819
43.6%
1 80415
 
13.1%
2 59437
 
9.7%
3 43028
 
7.0%
4 33218
 
5.4%
5 26863
 
4.4%
6 25008
 
4.1%
7 22210
 
3.6%
8 20304
 
3.3%
9 19441
 
3.2%
Other values (26) 15875
 
2.6%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 612618
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
0 266819
43.6%
1 80415
 
13.1%
2 59437
 
9.7%
3 43028
 
7.0%
4 33218
 
5.4%
5 26863
 
4.4%
6 25008
 
4.1%
7 22210
 
3.6%
8 20304
 
3.3%
9 19441
 
3.2%
Other values (26) 15875
 
2.6%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 612618
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
0 266819
43.6%
1 80415
 
13.1%
2 59437
 
9.7%
3 43028
 
7.0%
4 33218
 
5.4%
5 26863
 
4.4%
6 25008
 
4.1%
7 22210
 
3.6%
8 20304
 
3.3%
9 19441
 
3.2%
Other values (26) 15875
 
2.6%

Street Number
Real number (ℝ)

Distinct5099
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1121.7155
Minimum0
Maximum8400
Zeros4
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size1.5 MiB
2024-08-30T20:24:12.538014image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile32
Q1235
median710
Q31700
95-th percentile3481
Maximum8400
Range8400
Interquartile range (IQR)1465

Descriptive statistics

Standard deviation1135.7985
Coefficient of variation (CV)1.0125548
Kurtosis2.1350541
Mean1121.7155
Median Absolute Deviation (MAD)580
Skewness1.4269693
Sum2.2312044 × 108
Variance1290038.2
MonotonicityNot monotonic
2024-08-30T20:24:12.996676image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 2398
 
1.2%
101 1153
 
0.6%
100 1143
 
0.6%
50 1103
 
0.6%
201 1026
 
0.5%
555 994
 
0.5%
2 814
 
0.4%
55 734
 
0.4%
350 705
 
0.4%
150 672
 
0.3%
Other values (5089) 188168
94.6%
ValueCountFrequency (%)
0 4
 
< 0.1%
1 2398
1.2%
2 814
 
0.4%
3 309
 
0.2%
4 255
 
0.1%
5 194
 
0.1%
6 113
 
0.1%
7 132
 
0.1%
8 281
 
0.1%
9 128
 
0.1%
ValueCountFrequency (%)
8400 3
< 0.1%
8331 1
 
< 0.1%
8325 5
< 0.1%
8320 1
 
< 0.1%
8300 1
 
< 0.1%
8245 1
 
< 0.1%
8231 1
 
< 0.1%
8228 1
 
< 0.1%
8222 7
< 0.1%
8219 1
 
< 0.1%

Street Number Suffix
Categorical

HIGH CORRELATION  IMBALANCE  MISSING 

Distinct18
Distinct (%)0.8%
Missing196694
Missing (%)98.9%
Memory size10.6 MiB
A
1501 
B
291 
V
228 
C
 
56
E
 
28
Other values (13)
 
112

Length

Max length1
Median length1
Mean length1
Min length1

Characters and Unicode

Total characters2216
Distinct characters18
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2 ?
Unique (%)0.1%

Sample

1st rowB
2nd rowA
3rd rowV
4th rowA
5th rowV

Common Values

ValueCountFrequency (%)
A 1501
 
0.8%
B 291
 
0.1%
V 228
 
0.1%
C 56
 
< 0.1%
E 28
 
< 0.1%
F 24
 
< 0.1%
G 12
 
< 0.1%
D 11
 
< 0.1%
H 11
 
< 0.1%
K 11
 
< 0.1%
Other values (8) 43
 
< 0.1%
(Missing) 196694
98.9%

Length

2024-08-30T20:24:13.371036image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
a 1501
67.7%
b 291
 
13.1%
v 228
 
10.3%
c 56
 
2.5%
e 28
 
1.3%
f 24
 
1.1%
g 12
 
0.5%
h 11
 
0.5%
k 11
 
0.5%
d 11
 
0.5%
Other values (8) 43
 
1.9%

Most occurring characters

ValueCountFrequency (%)
A 1501
67.7%
B 291
 
13.1%
V 228
 
10.3%
C 56
 
2.5%
E 28
 
1.3%
F 24
 
1.1%
G 12
 
0.5%
H 11
 
0.5%
K 11
 
0.5%
D 11
 
0.5%
Other values (8) 43
 
1.9%

Most occurring categories

ValueCountFrequency (%)
(unknown) 2216
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
A 1501
67.7%
B 291
 
13.1%
V 228
 
10.3%
C 56
 
2.5%
E 28
 
1.3%
F 24
 
1.1%
G 12
 
0.5%
H 11
 
0.5%
K 11
 
0.5%
D 11
 
0.5%
Other values (8) 43
 
1.9%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 2216
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
A 1501
67.7%
B 291
 
13.1%
V 228
 
10.3%
C 56
 
2.5%
E 28
 
1.3%
F 24
 
1.1%
G 12
 
0.5%
H 11
 
0.5%
K 11
 
0.5%
D 11
 
0.5%
Other values (8) 43
 
1.9%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 2216
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
A 1501
67.7%
B 291
 
13.1%
V 228
 
10.3%
C 56
 
2.5%
E 28
 
1.3%
F 24
 
1.1%
G 12
 
0.5%
H 11
 
0.5%
K 11
 
0.5%
D 11
 
0.5%
Other values (8) 43
 
1.9%
Distinct1714
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size12.0 MiB
2024-08-30T20:24:14.226170image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Length

Max length25
Median length22
Mean length6.5098185
Min length3

Characters and Unicode

Total characters1294868
Distinct characters65
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique117 ?
Unique (%)0.1%

Sample

1st rowjOnEs
2nd row43rD
3rd rowpReNtIsS
4th rowbUsH
5th rowcApP
ValueCountFrequency (%)
market 5443
 
2.6%
california 4587
 
2.2%
mission 4324
 
2.0%
montgomery 2933
 
1.4%
geary 1966
 
0.9%
20th 1859
 
0.9%
03rd 1819
 
0.9%
folsom 1776
 
0.8%
van 1698
 
0.8%
pine 1678
 
0.8%
Other values (1705) 184679
86.8%
2024-08-30T20:24:15.428995image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
A 83888
 
6.5%
O 63275
 
4.9%
e 55861
 
4.3%
n 55448
 
4.3%
r 54146
 
4.2%
E 54117
 
4.2%
t 51943
 
4.0%
s 49681
 
3.8%
R 45151
 
3.5%
T 42390
 
3.3%
Other values (55) 738968
57.1%

Most occurring categories

ValueCountFrequency (%)
(unknown) 1294868
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
A 83888
 
6.5%
O 63275
 
4.9%
e 55861
 
4.3%
n 55448
 
4.3%
r 54146
 
4.2%
E 54117
 
4.2%
t 51943
 
4.0%
s 49681
 
3.8%
R 45151
 
3.5%
T 42390
 
3.3%
Other values (55) 738968
57.1%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 1294868
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
A 83888
 
6.5%
O 63275
 
4.9%
e 55861
 
4.3%
n 55448
 
4.3%
r 54146
 
4.2%
E 54117
 
4.2%
t 51943
 
4.0%
s 49681
 
3.8%
R 45151
 
3.5%
T 42390
 
3.3%
Other values (55) 738968
57.1%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 1294868
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
A 83888
 
6.5%
O 63275
 
4.9%
e 55861
 
4.3%
n 55448
 
4.3%
r 54146
 
4.2%
E 54117
 
4.2%
t 51943
 
4.0%
s 49681
 
3.8%
R 45151
 
3.5%
T 42390
 
3.3%
Other values (55) 738968
57.1%

Street Suffix
Categorical

IMBALANCE  MISSING 

Distinct21
Distinct (%)< 0.1%
Missing2768
Missing (%)1.4%
Memory size11.2 MiB
St
138365 
Av
43222 
Bl
 
3555
Wy
 
3540
Dr
 
3267
Other values (16)
 
4193

Length

Max length2
Median length2
Mean length2
Min length2

Characters and Unicode

Total characters392284
Distinct characters23
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st rowSt
2nd rowAv
3rd rowSt
4th rowSt
5th rowSt

Common Values

ValueCountFrequency (%)
St 138365
69.6%
Av 43222
 
21.7%
Bl 3555
 
1.8%
Wy 3540
 
1.8%
Dr 3267
 
1.6%
Tr 1466
 
0.7%
Ct 667
 
0.3%
Pl 538
 
0.3%
Rd 389
 
0.2%
Ln 354
 
0.2%
Other values (11) 779
 
0.4%
(Missing) 2768
 
1.4%

Length

2024-08-30T20:24:15.744964image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
st 138365
70.5%
av 43222
 
22.0%
bl 3555
 
1.8%
wy 3540
 
1.8%
dr 3267
 
1.7%
tr 1466
 
0.7%
ct 667
 
0.3%
pl 538
 
0.3%
rd 389
 
0.2%
ln 354
 
0.2%
Other values (11) 779
 
0.4%

Most occurring characters

ValueCountFrequency (%)
t 139032
35.4%
S 138369
35.3%
A 43305
 
11.0%
v 43222
 
11.0%
r 4830
 
1.2%
l 4177
 
1.1%
y 3780
 
1.0%
B 3555
 
0.9%
W 3549
 
0.9%
D 3267
 
0.8%
Other values (13) 5198
 
1.3%

Most occurring categories

ValueCountFrequency (%)
(unknown) 392284
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
t 139032
35.4%
S 138369
35.3%
A 43305
 
11.0%
v 43222
 
11.0%
r 4830
 
1.2%
l 4177
 
1.1%
y 3780
 
1.0%
B 3555
 
0.9%
W 3549
 
0.9%
D 3267
 
0.8%
Other values (13) 5198
 
1.3%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 392284
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
t 139032
35.4%
S 138369
35.3%
A 43305
 
11.0%
v 43222
 
11.0%
r 4830
 
1.2%
l 4177
 
1.1%
y 3780
 
1.0%
B 3555
 
0.9%
W 3549
 
0.9%
D 3267
 
0.8%
Other values (13) 5198
 
1.3%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 392284
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
t 139032
35.4%
S 138369
35.3%
A 43305
 
11.0%
v 43222
 
11.0%
r 4830
 
1.2%
l 4177
 
1.1%
y 3780
 
1.0%
B 3555
 
0.9%
W 3549
 
0.9%
D 3267
 
0.8%
Other values (13) 5198
 
1.3%

Unit
Real number (ℝ)

MISSING  ZEROS 

Distinct660
Distinct (%)2.2%
Missing169430
Missing (%)85.2%
Infinite0
Infinite (%)0.0%
Mean78.514518
Minimum0
Maximum6004
Zeros21411
Zeros (%)10.8%
Negative0
Negative (%)0.0%
Memory size1.5 MiB
2024-08-30T20:24:16.130911image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31
95-th percentile446.1
Maximum6004
Range6004
Interquartile range (IQR)1

Descriptive statistics

Standard deviation326.9761
Coefficient of variation (CV)4.1645304
Kurtosis92.15637
Mean78.514518
Median Absolute Deviation (MAD)0
Skewness8.1334162
Sum2314608
Variance106913.37
MonotonicityNot monotonic
2024-08-30T20:24:16.593055image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 21411
 
10.8%
1 1312
 
0.7%
2 549
 
0.3%
3 448
 
0.2%
101 365
 
0.2%
4 288
 
0.1%
6 214
 
0.1%
5 211
 
0.1%
201 210
 
0.1%
8 104
 
0.1%
Other values (650) 4368
 
2.2%
(Missing) 169430
85.2%
ValueCountFrequency (%)
0 21411
10.8%
1 1312
 
0.7%
2 549
 
0.3%
3 448
 
0.2%
4 288
 
0.1%
5 211
 
0.1%
6 214
 
0.1%
7 103
 
0.1%
8 104
 
0.1%
9 69
 
< 0.1%
ValueCountFrequency (%)
6004 1
 
< 0.1%
6003 3
< 0.1%
5903 1
 
< 0.1%
5604 1
 
< 0.1%
5602 1
 
< 0.1%
5413 1
 
< 0.1%
5412 1
 
< 0.1%
5313 1
 
< 0.1%
5312 1
 
< 0.1%
5306 1
 
< 0.1%

Unit Suffix
Text

MISSING 

Distinct164
Distinct (%)8.4%
Missing196949
Missing (%)99.0%
Memory size6.1 MiB
2024-08-30T20:24:17.258633image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Length

Max length10
Median length1
Mean length2.6017338
Min length1

Characters and Unicode

Total characters5102
Distinct characters46
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique60 ?
Unique (%)3.1%

Sample

1st rowC
2nd rowC
3rd rowRESID'L
4th rowD
5th rowE
ValueCountFrequency (%)
a 354
16.5%
c 229
 
10.7%
b 199
 
9.3%
d 137
 
6.4%
e 93
 
4.3%
bldg 93
 
4.3%
hoa 85
 
4.0%
f 78
 
3.6%
comml 51
 
2.4%
front 48
 
2.2%
Other values (135) 782
36.4%
2024-08-30T20:24:18.164346image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
A 545
 
10.7%
C 409
 
8.0%
E 321
 
6.3%
B 315
 
6.2%
R 311
 
6.1%
D 295
 
5.8%
O 264
 
5.2%
L 261
 
5.1%
F 208
 
4.1%
188
 
3.7%
Other values (36) 1985
38.9%

Most occurring categories

ValueCountFrequency (%)
(unknown) 5102
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
A 545
 
10.7%
C 409
 
8.0%
E 321
 
6.3%
B 315
 
6.2%
R 311
 
6.1%
D 295
 
5.8%
O 264
 
5.2%
L 261
 
5.1%
F 208
 
4.1%
188
 
3.7%
Other values (36) 1985
38.9%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 5102
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
A 545
 
10.7%
C 409
 
8.0%
E 321
 
6.3%
B 315
 
6.2%
R 311
 
6.1%
D 295
 
5.8%
O 264
 
5.2%
L 261
 
5.1%
F 208
 
4.1%
188
 
3.7%
Other values (36) 1985
38.9%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 5102
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
A 545
 
10.7%
C 409
 
8.0%
E 321
 
6.3%
B 315
 
6.2%
R 311
 
6.1%
D 295
 
5.8%
O 264
 
5.2%
L 261
 
5.1%
F 208
 
4.1%
188
 
3.7%
Other values (36) 1985
38.9%
Distinct134272
Distinct (%)67.6%
Missing290
Missing (%)0.1%
Memory size30.0 MiB
2024-08-30T20:24:19.050670image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Length

Max length300
Median length243
Mean length101.45318
Min length1

Characters and Unicode

Total characters20150631
Distinct characters76
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique122032 ?
Unique (%)61.4%

Sample

1st rowstreet space
2nd rowremodel kitchen: replace countertop, cabinets, sink, stove, hardwood floor & lighting.
3rd rowreplacement of 4 windows; 2 located in lightwell and 2 at front. replaceing existing vinyl windows with new wood-clad windows. no horizontal mullion in living room window
4th rowtwo kitchens & two bathrooms remodel. replace kitchen cabinets, countertops & appliances in same location. replace tub & faucet & vanity & tile in same location in both units.
5th rowreroofing
ValueCountFrequency (%)
94921
 
3.0%
to 93338
 
2.9%
and 68894
 
2.2%
new 61786
 
1.9%
of 54700
 
1.7%
street 44273
 
1.4%
space 41100
 
1.3%
replace 36545
 
1.1%
in 36109
 
1.1%
for 35061
 
1.1%
Other values (109535) 2636742
82.3%
2024-08-30T20:24:20.662373image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3042851
15.1%
e 1735300
 
8.6%
o 1280056
 
6.4%
r 1277846
 
6.3%
t 1208273
 
6.0%
n 1153984
 
5.7%
a 1149599
 
5.7%
i 1122199
 
5.6%
s 828425
 
4.1%
l 785552
 
3.9%
Other values (66) 6566546
32.6%

Most occurring categories

ValueCountFrequency (%)
(unknown) 20150631
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
3042851
15.1%
e 1735300
 
8.6%
o 1280056
 
6.4%
r 1277846
 
6.3%
t 1208273
 
6.0%
n 1153984
 
5.7%
a 1149599
 
5.7%
i 1122199
 
5.6%
s 828425
 
4.1%
l 785552
 
3.9%
Other values (66) 6566546
32.6%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 20150631
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
3042851
15.1%
e 1735300
 
8.6%
o 1280056
 
6.4%
r 1277846
 
6.3%
t 1208273
 
6.0%
n 1153984
 
5.7%
a 1149599
 
5.7%
i 1122199
 
5.6%
s 828425
 
4.1%
l 785552
 
3.9%
Other values (66) 6566546
32.6%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 20150631
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
3042851
15.1%
e 1735300
 
8.6%
o 1280056
 
6.4%
r 1277846
 
6.3%
t 1208273
 
6.0%
n 1153984
 
5.7%
a 1149599
 
5.7%
i 1122199
 
5.6%
s 828425
 
4.1%
l 785552
 
3.9%
Other values (66) 6566546
32.6%

Current Status
Categorical

IMBALANCE 

Distinct14
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size12.1 MiB
complete
97081 
issued
83563 
filed
12045 
withdrawn
 
1754
cancelled
 
1536
Other values (9)
 
2931

Length

Max length11
Median length10
Mean length6.9923282
Min length5

Characters and Unicode

Total characters1390844
Distinct characters20
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowissued
2nd rowcomplete
3rd rowissued
4th rowcomplete
5th rowissued

Common Values

ValueCountFrequency (%)
complete 97081
48.8%
issued 83563
42.0%
filed 12045
 
6.1%
withdrawn 1754
 
0.9%
cancelled 1536
 
0.8%
expired 1370
 
0.7%
approved 733
 
0.4%
reinstated 563
 
0.3%
suspend 193
 
0.1%
revoked 50
 
< 0.1%
Other values (4) 22
 
< 0.1%

Length

2024-08-30T20:24:21.035684image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
complete 97081
48.8%
issued 83563
42.0%
filed 12045
 
6.1%
withdrawn 1754
 
0.9%
cancelled 1536
 
0.8%
expired 1370
 
0.7%
approved 733
 
0.4%
reinstated 563
 
0.3%
suspend 193
 
0.1%
revoked 50
 
< 0.1%
Other values (4) 22
 
< 0.1%

Most occurring characters

ValueCountFrequency (%)
e 297758
21.4%
s 168077
12.1%
l 112218
 
8.1%
d 101811
 
7.3%
c 100187
 
7.2%
p 100136
 
7.2%
t 99963
 
7.2%
i 99299
 
7.1%
o 97868
 
7.0%
m 97083
 
7.0%
Other values (10) 116444
 
8.4%

Most occurring categories

ValueCountFrequency (%)
(unknown) 1390844
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
e 297758
21.4%
s 168077
12.1%
l 112218
 
8.1%
d 101811
 
7.3%
c 100187
 
7.2%
p 100136
 
7.2%
t 99963
 
7.2%
i 99299
 
7.1%
o 97868
 
7.0%
m 97083
 
7.0%
Other values (10) 116444
 
8.4%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 1390844
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
e 297758
21.4%
s 168077
12.1%
l 112218
 
8.1%
d 101811
 
7.3%
c 100187
 
7.2%
p 100136
 
7.2%
t 99963
 
7.2%
i 99299
 
7.1%
o 97868
 
7.0%
m 97083
 
7.0%
Other values (10) 116444
 
8.4%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 1390844
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
e 297758
21.4%
s 168077
12.1%
l 112218
 
8.1%
d 101811
 
7.3%
c 100187
 
7.2%
p 100136
 
7.2%
t 99963
 
7.2%
i 99299
 
7.1%
o 97868
 
7.0%
m 97083
 
7.0%
Other values (10) 116444
 
8.4%
Distinct1307
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.5 MiB
Minimum2013-01-02 00:00:00
Maximum2019-03-02 00:00:00
2024-08-30T20:24:21.473457image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:24:21.964765image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct1288
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.5 MiB
Minimum2013-01-02 00:00:00
Maximum2018-02-23 00:00:00
2024-08-30T20:24:22.513400image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:24:22.956735image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Issued Date
Date

MISSING 

Distinct1289
Distinct (%)0.7%
Missing14942
Missing (%)7.5%
Memory size1.5 MiB
Minimum2013-01-02 00:00:00
Maximum2018-02-23 00:00:00
2024-08-30T20:24:23.411060image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:24:23.874756image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Completed Date
Date

MISSING 

Distinct1300
Distinct (%)1.3%
Missing101715
Missing (%)51.1%
Memory size1.5 MiB
Minimum2013-01-04 00:00:00
Maximum2018-02-23 00:00:00
2024-08-30T20:24:24.397954image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:24:24.914735image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct1288
Distinct (%)0.7%
Missing14948
Missing (%)7.5%
Memory size1.5 MiB
Minimum2013-01-02 00:00:00
Maximum2018-02-23 00:00:00
2024-08-30T20:24:25.400150image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:24:25.863308image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Structural Notification
Boolean

CONSTANT  MISSING 

Distinct1
Distinct (%)< 0.1%
Missing191988
Missing (%)96.5%
Memory size388.6 KiB
True
 
6922
(Missing)
191988 
ValueCountFrequency (%)
True 6922
 
3.5%
(Missing) 191988
96.5%
2024-08-30T20:24:26.250806image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Number of Existing Stories
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct64
Distinct (%)< 0.1%
Missing42788
Missing (%)21.5%
Infinite0
Infinite (%)0.0%
Mean5.7057077
Minimum0
Maximum78
Zeros442
Zeros (%)0.2%
Negative0
Negative (%)0.0%
Memory size1.5 MiB
2024-08-30T20:24:26.602108image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q12
median3
Q34
95-th percentile26
Maximum78
Range78
Interquartile range (IQR)2

Descriptive statistics

Standard deviation8.6133098
Coefficient of variation (CV)1.5095953
Kurtosis11.309873
Mean5.7057077
Median Absolute Deviation (MAD)1
Skewness3.2978123
Sum890786.5
Variance74.189106
MonotonicityNot monotonic
2024-08-30T20:24:27.018570image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2 52770
26.5%
3 45741
23.0%
4 16055
 
8.1%
1 8793
 
4.4%
5 3767
 
1.9%
6 3696
 
1.9%
7 2359
 
1.2%
8 1732
 
0.9%
9 1264
 
0.6%
10 1129
 
0.6%
Other values (54) 18816
 
9.5%
(Missing) 42788
21.5%
ValueCountFrequency (%)
0 442
 
0.2%
1 8793
 
4.4%
1.5 1
 
< 0.1%
2 52770
26.5%
2.5 2
 
< 0.1%
3 45741
23.0%
4 16055
 
8.1%
5 3767
 
1.9%
6 3696
 
1.9%
7 2359
 
1.2%
ValueCountFrequency (%)
78 1
 
< 0.1%
63 99
< 0.1%
62 2
 
< 0.1%
61 24
 
< 0.1%
60 18
 
< 0.1%
58 93
< 0.1%
56 4
 
< 0.1%
55 14
 
< 0.1%
54 7
 
< 0.1%
53 12
 
< 0.1%

Number of Proposed Stories
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct64
Distinct (%)< 0.1%
Missing42871
Missing (%)21.6%
Infinite0
Infinite (%)0.0%
Mean5.7449644
Minimum0
Maximum78
Zeros174
Zeros (%)0.1%
Negative0
Negative (%)0.0%
Memory size1.5 MiB
2024-08-30T20:24:27.420304image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q12
median3
Q34
95-th percentile26
Maximum78
Range78
Interquartile range (IQR)2

Descriptive statistics

Standard deviation8.6131126
Coefficient of variation (CV)1.4992456
Kurtosis11.46678
Mean5.7449644
Median Absolute Deviation (MAD)1
Skewness3.3179006
Sum896438.5
Variance74.185708
MonotonicityNot monotonic
2024-08-30T20:24:27.898184image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2 50994
25.6%
3 46803
23.5%
4 17594
 
8.8%
1 7893
 
4.0%
5 4044
 
2.0%
6 3792
 
1.9%
7 2318
 
1.2%
8 1703
 
0.9%
9 1334
 
0.7%
11 1120
 
0.6%
Other values (54) 18444
 
9.3%
(Missing) 42871
21.6%
ValueCountFrequency (%)
0 174
 
0.1%
1 7893
 
4.0%
1.5 1
 
< 0.1%
2 50994
25.6%
2.5 2
 
< 0.1%
3 46803
23.5%
4 17594
 
8.8%
5 4044
 
2.0%
6 3792
 
1.9%
7 2318
 
1.2%
ValueCountFrequency (%)
78 1
 
< 0.1%
63 105
0.1%
62 4
 
< 0.1%
61 24
 
< 0.1%
60 19
 
< 0.1%
58 90
< 0.1%
56 11
 
< 0.1%
55 23
 
< 0.1%
54 14
 
< 0.1%
53 12
 
< 0.1%

Voluntary Soft-Story Retrofit
Boolean

CONSTANT  MISSING 

Distinct1
Distinct (%)2.9%
Missing198875
Missing (%)> 99.9%
Memory size388.6 KiB
True
 
35
(Missing)
198875 
ValueCountFrequency (%)
True 35
 
< 0.1%
(Missing) 198875
> 99.9%
2024-08-30T20:24:28.269285image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Fire Only Permit
Boolean

CONSTANT  MISSING 

Distinct1
Distinct (%)< 0.1%
Missing180082
Missing (%)90.5%
Memory size388.6 KiB
True
18828 
(Missing)
180082 
ValueCountFrequency (%)
True 18828
 
9.5%
(Missing) 180082
90.5%
2024-08-30T20:24:28.538538image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Distinct2232
Distinct (%)1.5%
Missing51884
Missing (%)26.1%
Memory size1.5 MiB
Minimum2013-07-15 00:00:00
Maximum2024-02-21 00:00:00
2024-08-30T20:24:28.892363image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:24:29.356448image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Estimated Cost
Real number (ℝ)

HIGH CORRELATION  MISSING  SKEWED 

Distinct11395
Distinct (%)7.1%
Missing38068
Missing (%)19.1%
Infinite0
Infinite (%)0.0%
Mean169009.86
Minimum1
Maximum5.3795865 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 MiB
2024-08-30T20:24:29.825948image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q13300
median11000
Q335000
95-th percentile275000
Maximum5.3795865 × 108
Range5.3795864 × 108
Interquartile range (IQR)31700

Descriptive statistics

Standard deviation3630376.9
Coefficient of variation (CV)21.480267
Kurtosis8911.3386
Mean169009.86
Median Absolute Deviation (MAD)10000
Skewness80.264355
Sum2.7183884 × 1010
Variance1.3179636 × 1013
MonotonicityNot monotonic
2024-08-30T20:24:30.284260image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 17014
 
8.6%
10000 6695
 
3.4%
5000 6437
 
3.2%
20000 5702
 
2.9%
15000 4779
 
2.4%
30000 3939
 
2.0%
25000 3599
 
1.8%
3000 3569
 
1.8%
50000 3345
 
1.7%
2000 3203
 
1.6%
Other values (11385) 102560
51.6%
(Missing) 38068
 
19.1%
ValueCountFrequency (%)
1 17014
8.6%
2 1
 
< 0.1%
4 2
 
< 0.1%
5 3
 
< 0.1%
10 11
 
< 0.1%
20 5
 
< 0.1%
25 7
 
< 0.1%
30 3
 
< 0.1%
35 1
 
< 0.1%
40 1
 
< 0.1%
ValueCountFrequency (%)
537958646 1
< 0.1%
520000000 1
< 0.1%
400000000 2
< 0.1%
340000000 1
< 0.1%
272000000 1
< 0.1%
270000000 1
< 0.1%
239000000 1
< 0.1%
210000000 1
< 0.1%
175000000 1
< 0.1%
167000000 2
< 0.1%

Revised Cost
Real number (ℝ)

HIGH CORRELATION  MISSING  SKEWED  ZEROS 

Distinct12629
Distinct (%)6.5%
Missing6066
Missing (%)3.0%
Infinite0
Infinite (%)0.0%
Mean132901.75
Minimum0
Maximum7.805 × 108
Zeros8514
Zeros (%)4.3%
Negative0
Negative (%)0.0%
Memory size1.5 MiB
2024-08-30T20:24:30.898394image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q11
median7000
Q328715
95-th percentile227340
Maximum7.805 × 108
Range7.805 × 108
Interquartile range (IQR)28714

Descriptive statistics

Standard deviation3584878.7
Coefficient of variation (CV)26.973901
Kurtosis17049.467
Mean132901.75
Median Absolute Deviation (MAD)6999
Skewness108.7016
Sum2.5629306 × 1010
Variance1.2851355 × 1013
MonotonicityNot monotonic
2024-08-30T20:24:31.377089image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 47229
23.7%
0 8514
 
4.3%
10000 5474
 
2.8%
5000 5453
 
2.7%
20000 4696
 
2.4%
15000 4001
 
2.0%
30000 3291
 
1.7%
25000 3135
 
1.6%
3000 3067
 
1.5%
2000 2955
 
1.5%
Other values (12619) 105029
52.8%
(Missing) 6066
 
3.0%
ValueCountFrequency (%)
0 8514
 
4.3%
0.01 1
 
< 0.1%
1 47229
23.7%
1.2 1
 
< 0.1%
2 4
 
< 0.1%
5 3
 
< 0.1%
10 11
 
< 0.1%
12 1
 
< 0.1%
13 1
 
< 0.1%
14 6
 
< 0.1%
ValueCountFrequency (%)
780500000 1
 
< 0.1%
520000000 1
 
< 0.1%
400000000 2
< 0.1%
336200000 1
 
< 0.1%
270000000 1
 
< 0.1%
266061486 1
 
< 0.1%
239000000 1
 
< 0.1%
210000000 1
 
< 0.1%
207680000 1
 
< 0.1%
200000000 4
< 0.1%

Existing Use
Text

MISSING 

Distinct93
Distinct (%)0.1%
Missing41117
Missing (%)20.7%
Memory size11.8 MiB
2024-08-30T20:24:32.417186image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Length

Max length20
Median length19
Mean length13.170286
Min length4

Characters and Unicode

Total characters2078179
Distinct characters39
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique4 ?
Unique (%)< 0.1%

Sample

1st row1 family dwelling
2nd row1 family dwelling
3rd row2 family dwelling
4th rowapartments
5th rowapartments
ValueCountFrequency (%)
family 67756
21.4%
dwelling 67756
21.4%
1 46768
14.8%
apartments 40800
12.9%
office 24617
 
7.8%
2 20988
 
6.6%
sales 7032
 
2.2%
retail 6910
 
2.2%
hndlng 4886
 
1.5%
food/beverage 4886
 
1.5%
Other values (144) 24040
 
7.6%
2024-08-30T20:24:33.847773image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
l 235150
 
11.3%
a 181738
 
8.7%
i 179803
 
8.7%
e 177532
 
8.5%
158646
 
7.6%
n 129792
 
6.2%
f 123927
 
6.0%
m 113200
 
5.4%
t 108688
 
5.2%
d 81432
 
3.9%
Other values (29) 588271
28.3%

Most occurring categories

ValueCountFrequency (%)
(unknown) 2078179
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
l 235150
 
11.3%
a 181738
 
8.7%
i 179803
 
8.7%
e 177532
 
8.5%
158646
 
7.6%
n 129792
 
6.2%
f 123927
 
6.0%
m 113200
 
5.4%
t 108688
 
5.2%
d 81432
 
3.9%
Other values (29) 588271
28.3%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 2078179
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
l 235150
 
11.3%
a 181738
 
8.7%
i 179803
 
8.7%
e 177532
 
8.5%
158646
 
7.6%
n 129792
 
6.2%
f 123927
 
6.0%
m 113200
 
5.4%
t 108688
 
5.2%
d 81432
 
3.9%
Other values (29) 588271
28.3%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 2078179
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
l 235150
 
11.3%
a 181738
 
8.7%
i 179803
 
8.7%
e 177532
 
8.5%
158646
 
7.6%
n 129792
 
6.2%
f 123927
 
6.0%
m 113200
 
5.4%
t 108688
 
5.2%
d 81432
 
3.9%
Other values (29) 588271
28.3%

Existing Units
Real number (ℝ)

HIGH CORRELATION  MISSING  ZEROS 

Distinct348
Distinct (%)0.2%
Missing51543
Missing (%)25.9%
Infinite0
Infinite (%)0.0%
Mean15.666006
Minimum0
Maximum1907
Zeros29135
Zeros (%)14.6%
Negative0
Negative (%)0.0%
Memory size1.5 MiB
2024-08-30T20:24:34.236955image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11
median1
Q34
95-th percentile64
Maximum1907
Range1907
Interquartile range (IQR)3

Descriptive statistics

Standard deviation74.47512
Coefficient of variation (CV)4.7539316
Kurtosis238.3122
Mean15.666006
Median Absolute Deviation (MAD)1
Skewness12.867436
Sum2308652.3
Variance5546.5435
MonotonicityNot monotonic
2024-08-30T20:24:34.742388image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 47347
23.8%
0 29135
14.6%
2 21805
11.0%
3 8616
 
4.3%
6 6066
 
3.0%
4 5364
 
2.7%
12 2535
 
1.3%
5 2347
 
1.2%
8 1728
 
0.9%
9 1188
 
0.6%
Other values (338) 21236
10.7%
(Missing) 51543
25.9%
ValueCountFrequency (%)
0 29135
14.6%
0.3 1
 
< 0.1%
1 47347
23.8%
2 21805
11.0%
3 8616
 
4.3%
4 5364
 
2.7%
5 2347
 
1.2%
6 6066
 
3.0%
7 1172
 
0.6%
8 1728
 
0.9%
ValueCountFrequency (%)
1907 44
< 0.1%
1732 8
 
< 0.1%
1500 51
< 0.1%
1499 1
 
< 0.1%
1186 51
< 0.1%
1010 2
 
< 0.1%
1005 21
< 0.1%
1004 2
 
< 0.1%
1000 1
 
< 0.1%
948 1
 
< 0.1%

Proposed Use
Text

MISSING 

Distinct94
Distinct (%)0.1%
Missing42441
Missing (%)21.3%
Memory size11.8 MiB
2024-08-30T20:24:35.775782image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Length

Max length20
Median length19
Mean length13.208827
Min length4

Characters and Unicode

Total characters2066772
Distinct characters39
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique4 ?
Unique (%)< 0.1%

Sample

1st row1 family dwelling
2nd row1 family dwelling
3rd row2 family dwelling
4th rowapartments
5th rowapartments
ValueCountFrequency (%)
family 68410
21.8%
dwelling 68410
21.8%
1 46348
14.8%
apartments 43035
13.7%
office 23963
 
7.7%
2 22062
 
7.0%
sales 5193
 
1.7%
retail 5079
 
1.6%
food/beverage 5053
 
1.6%
hndlng 5053
 
1.6%
Other values (146) 20614
 
6.6%
2024-08-30T20:24:37.190784image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
l 232125
 
11.2%
a 179985
 
8.7%
i 177628
 
8.6%
e 175966
 
8.5%
156751
 
7.6%
n 130398
 
6.3%
f 123053
 
6.0%
m 116197
 
5.6%
t 107434
 
5.2%
d 82574
 
4.0%
Other values (29) 584661
28.3%

Most occurring categories

ValueCountFrequency (%)
(unknown) 2066772
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
l 232125
 
11.2%
a 179985
 
8.7%
i 177628
 
8.6%
e 175966
 
8.5%
156751
 
7.6%
n 130398
 
6.3%
f 123053
 
6.0%
m 116197
 
5.6%
t 107434
 
5.2%
d 82574
 
4.0%
Other values (29) 584661
28.3%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 2066772
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
l 232125
 
11.2%
a 179985
 
8.7%
i 177628
 
8.6%
e 175966
 
8.5%
156751
 
7.6%
n 130398
 
6.3%
f 123053
 
6.0%
m 116197
 
5.6%
t 107434
 
5.2%
d 82574
 
4.0%
Other values (29) 584661
28.3%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 2066772
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
l 232125
 
11.2%
a 179985
 
8.7%
i 177628
 
8.6%
e 175966
 
8.5%
156751
 
7.6%
n 130398
 
6.3%
f 123053
 
6.0%
m 116197
 
5.6%
t 107434
 
5.2%
d 82574
 
4.0%
Other values (29) 584661
28.3%

Proposed Units
Real number (ℝ)

HIGH CORRELATION  MISSING  ZEROS 

Distinct368
Distinct (%)0.2%
Missing50915
Missing (%)25.6%
Infinite0
Infinite (%)0.0%
Mean16.510882
Minimum0
Maximum1911
Zeros26885
Zeros (%)13.5%
Negative0
Negative (%)0.0%
Memory size1.5 MiB
2024-08-30T20:24:37.575925image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11
median2
Q34
95-th percentile70
Maximum1911
Range1911
Interquartile range (IQR)3

Descriptive statistics

Standard deviation75.218997
Coefficient of variation (CV)4.5557225
Kurtosis223.71262
Mean16.510882
Median Absolute Deviation (MAD)1
Skewness12.330487
Sum2443528
Variance5657.8975
MonotonicityNot monotonic
2024-08-30T20:24:38.170526image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 46914
23.6%
0 26885
13.5%
2 22892
11.5%
3 9347
 
4.7%
6 5872
 
3.0%
4 5504
 
2.8%
12 2474
 
1.2%
5 2400
 
1.2%
8 1800
 
0.9%
7 1336
 
0.7%
Other values (358) 22571
11.3%
(Missing) 50915
25.6%
ValueCountFrequency (%)
0 26885
13.5%
1 46914
23.6%
2 22892
11.5%
3 9347
 
4.7%
4 5504
 
2.8%
5 2400
 
1.2%
6 5872
 
3.0%
7 1336
 
0.7%
8 1800
 
0.9%
9 1270
 
0.6%
ValueCountFrequency (%)
1911 1
 
< 0.1%
1907 43
< 0.1%
1732 8
 
< 0.1%
1500 48
< 0.1%
1499 1
 
< 0.1%
1199 1
 
< 0.1%
1186 47
< 0.1%
1014 4
 
< 0.1%
1010 2
 
< 0.1%
1005 17
 
< 0.1%

Plansets
Real number (ℝ)

HIGH CORRELATION  MISSING  SKEWED  ZEROS 

Distinct8
Distinct (%)< 0.1%
Missing37311
Missing (%)18.8%
Infinite0
Infinite (%)0.0%
Mean1.274649
Minimum0
Maximum9000
Zeros63247
Zeros (%)31.8%
Negative0
Negative (%)0.0%
Memory size1.5 MiB
2024-08-30T20:24:38.609344image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median2
Q32
95-th percentile2
Maximum9000
Range9000
Interquartile range (IQR)2

Descriptive statistics

Standard deviation22.406792
Coefficient of variation (CV)17.578794
Kurtosis160982
Mean1.274649
Median Absolute Deviation (MAD)0
Skewness400.84207
Sum205982
Variance502.06432
MonotonicityNot monotonic
2024-08-30T20:24:38.872489image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
2 98093
49.3%
0 63247
31.8%
3 250
 
0.1%
4 3
 
< 0.1%
6 2
 
< 0.1%
1 2
 
< 0.1%
20 1
 
< 0.1%
9000 1
 
< 0.1%
(Missing) 37311
 
18.8%
ValueCountFrequency (%)
0 63247
31.8%
1 2
 
< 0.1%
2 98093
49.3%
3 250
 
0.1%
4 3
 
< 0.1%
6 2
 
< 0.1%
20 1
 
< 0.1%
9000 1
 
< 0.1%
ValueCountFrequency (%)
9000 1
 
< 0.1%
20 1
 
< 0.1%
6 2
 
< 0.1%
4 3
 
< 0.1%
3 250
 
0.1%
2 98093
49.3%
1 2
 
< 0.1%
0 63247
31.8%

TIDF Compliance
Text

MISSING 

Distinct2
Distinct (%)100.0%
Missing198908
Missing (%)> 99.9%
Memory size6.1 MiB
2024-08-30T20:24:39.057320image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Length

Max length1
Median length1
Mean length1
Min length1

Characters and Unicode

Total characters2
Distinct characters2
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2 ?
Unique (%)100.0%

Sample

1st rowP
2nd rowY
ValueCountFrequency (%)
p 1
50.0%
y 1
50.0%
2024-08-30T20:24:39.521062image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
P 1
50.0%
Y 1
50.0%

Most occurring categories

ValueCountFrequency (%)
(unknown) 2
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
P 1
50.0%
Y 1
50.0%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 2
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
P 1
50.0%
Y 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 2
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
P 1
50.0%
Y 1
50.0%

Existing Construction Type
Real number (ℝ)

HIGH CORRELATION  MISSING  SKEWED 

Distinct7
Distinct (%)< 0.1%
Missing43369
Missing (%)21.8%
Infinite0
Infinite (%)0.0%
Mean4.7156312
Minimum-99999
Maximum99999
Zeros0
Zeros (%)0.0%
Negative2
Negative (%)< 0.1%
Memory size1.5 MiB
2024-08-30T20:24:39.774090image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Quantile statistics

Minimum-99999
5-th percentile1
Q13
median5
Q35
95-th percentile5
Maximum99999
Range199998
Interquartile range (IQR)2

Descriptive statistics

Standard deviation566.96662
Coefficient of variation (CV)120.23133
Kurtosis31105.634
Mean4.7156312
Median Absolute Deviation (MAD)0
Skewness35.250938
Sum733474
Variance321451.15
MonotonicityNot monotonic
2024-08-30T20:24:40.128410image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
5 113350
57.0%
1 28073
 
14.1%
3 9664
 
4.9%
2 4068
 
2.0%
4 381
 
0.2%
99999 3
 
< 0.1%
-99999 2
 
< 0.1%
(Missing) 43369
 
21.8%
ValueCountFrequency (%)
-99999 2
 
< 0.1%
1 28073
 
14.1%
2 4068
 
2.0%
3 9664
 
4.9%
4 381
 
0.2%
5 113350
57.0%
99999 3
 
< 0.1%
ValueCountFrequency (%)
99999 3
 
< 0.1%
5 113350
57.0%
4 381
 
0.2%
3 9664
 
4.9%
2 4068
 
2.0%
1 28073
 
14.1%
-99999 2
 
< 0.1%

Existing Construction Type Description
Categorical

HIGH CORRELATION  IMBALANCE  MISSING 

Distinct8
Distinct (%)< 0.1%
Missing43370
Missing (%)21.8%
Memory size12.8 MiB
wood frame (5)
113350 
constr type 1
28072 
constr type 3
 
9663
constr type 2
 
4068
constr type 4
 
381
Other values (3)
 
6

Length

Max length16
Median length14
Mean length13.728854
Min length13

Characters and Unicode

Total characters2135386
Distinct characters22
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2 ?
Unique (%)< 0.1%

Sample

1st rowwood frame (5)
2nd rowwood frame (5)
3rd rowwood frame (5)
4th rowwood frame (5)
5th rowwood frame (5)

Common Values

ValueCountFrequency (%)
wood frame (5) 113350
57.0%
constr type 1 28072
 
14.1%
constr type 3 9663
 
4.9%
constr type 2 4068
 
2.0%
constr type 4 381
 
0.2%
wood frame (5) 4
 
< 0.1%
constr type 1 1
 
< 0.1%
constr type 3 1
 
< 0.1%
(Missing) 43370
 
21.8%

Length

2024-08-30T20:24:40.553353image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-08-30T20:24:41.073461image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
ValueCountFrequency (%)
wood 113354
24.3%
frame 113354
24.3%
5 113354
24.3%
constr 42186
 
9.0%
type 42186
 
9.0%
1 28073
 
6.0%
3 9664
 
2.1%
2 4068
 
0.9%
4 381
 
0.1%

Most occurring characters

ValueCountFrequency (%)
311092
14.6%
o 268894
12.6%
e 155540
 
7.3%
r 155540
 
7.3%
w 113354
 
5.3%
5 113354
 
5.3%
( 113354
 
5.3%
) 113354
 
5.3%
m 113354
 
5.3%
a 113354
 
5.3%
Other values (12) 564196
26.4%

Most occurring categories

ValueCountFrequency (%)
(unknown) 2135386
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
311092
14.6%
o 268894
12.6%
e 155540
 
7.3%
r 155540
 
7.3%
w 113354
 
5.3%
5 113354
 
5.3%
( 113354
 
5.3%
) 113354
 
5.3%
m 113354
 
5.3%
a 113354
 
5.3%
Other values (12) 564196
26.4%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 2135386
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
311092
14.6%
o 268894
12.6%
e 155540
 
7.3%
r 155540
 
7.3%
w 113354
 
5.3%
5 113354
 
5.3%
( 113354
 
5.3%
) 113354
 
5.3%
m 113354
 
5.3%
a 113354
 
5.3%
Other values (12) 564196
26.4%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 2135386
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
311092
14.6%
o 268894
12.6%
e 155540
 
7.3%
r 155540
 
7.3%
w 113354
 
5.3%
5 113354
 
5.3%
( 113354
 
5.3%
) 113354
 
5.3%
m 113354
 
5.3%
a 113354
 
5.3%
Other values (12) 564196
26.4%

Proposed Construction Type
Categorical

HIGH CORRELATION  MISSING 

Distinct5
Distinct (%)< 0.1%
Missing43165
Missing (%)21.7%
Memory size11.2 MiB
5.0
114386 
1.0
27843 
3.0
 
9361
2.0
 
3778
4.0
 
377

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters467235
Distinct characters7
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row5.0
2nd row5.0
3rd row5.0
4th row5.0
5th row5.0

Common Values

ValueCountFrequency (%)
5.0 114386
57.5%
1.0 27843
 
14.0%
3.0 9361
 
4.7%
2.0 3778
 
1.9%
4.0 377
 
0.2%
(Missing) 43165
 
21.7%

Length

2024-08-30T20:24:41.551931image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-08-30T20:24:41.921492image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
ValueCountFrequency (%)
5.0 114386
73.4%
1.0 27843
 
17.9%
3.0 9361
 
6.0%
2.0 3778
 
2.4%
4.0 377
 
0.2%

Most occurring characters

ValueCountFrequency (%)
. 155745
33.3%
0 155745
33.3%
5 114386
24.5%
1 27843
 
6.0%
3 9361
 
2.0%
2 3778
 
0.8%
4 377
 
0.1%

Most occurring categories

ValueCountFrequency (%)
(unknown) 467235
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
. 155745
33.3%
0 155745
33.3%
5 114386
24.5%
1 27843
 
6.0%
3 9361
 
2.0%
2 3778
 
0.8%
4 377
 
0.1%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 467235
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
. 155745
33.3%
0 155745
33.3%
5 114386
24.5%
1 27843
 
6.0%
3 9361
 
2.0%
2 3778
 
0.8%
4 377
 
0.1%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 467235
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
. 155745
33.3%
0 155745
33.3%
5 114386
24.5%
1 27843
 
6.0%
3 9361
 
2.0%
2 3778
 
0.8%
4 377
 
0.1%

Proposed Construction Type Description
Categorical

HIGH CORRELATION  MISSING 

Distinct5
Distinct (%)< 0.1%
Missing43165
Missing (%)21.7%
Memory size12.8 MiB
wood frame (5)
114386 
constr type 1
27843 
constr type 3
 
9361
constr type 2
 
3778
constr type 4
 
377

Length

Max length14
Median length14
Mean length13.734444
Min length13

Characters and Unicode

Total characters2139071
Distinct characters22
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowwood frame (5)
2nd rowwood frame (5)
3rd rowwood frame (5)
4th rowwood frame (5)
5th rowwood frame (5)

Common Values

ValueCountFrequency (%)
wood frame (5) 114386
57.5%
constr type 1 27843
 
14.0%
constr type 3 9361
 
4.7%
constr type 2 3778
 
1.9%
constr type 4 377
 
0.2%
(Missing) 43165
 
21.7%

Length

2024-08-30T20:24:43.856583image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-08-30T20:24:44.265732image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
ValueCountFrequency (%)
wood 114386
24.5%
frame 114386
24.5%
5 114386
24.5%
constr 41359
 
8.9%
type 41359
 
8.9%
1 27843
 
6.0%
3 9361
 
2.0%
2 3778
 
0.8%
4 377
 
0.1%

Most occurring characters

ValueCountFrequency (%)
311490
14.6%
o 270131
12.6%
e 155745
 
7.3%
r 155745
 
7.3%
w 114386
 
5.3%
5 114386
 
5.3%
( 114386
 
5.3%
) 114386
 
5.3%
m 114386
 
5.3%
a 114386
 
5.3%
Other values (12) 559644
26.2%

Most occurring categories

ValueCountFrequency (%)
(unknown) 2139071
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
311490
14.6%
o 270131
12.6%
e 155745
 
7.3%
r 155745
 
7.3%
w 114386
 
5.3%
5 114386
 
5.3%
( 114386
 
5.3%
) 114386
 
5.3%
m 114386
 
5.3%
a 114386
 
5.3%
Other values (12) 559644
26.2%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 2139071
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
311490
14.6%
o 270131
12.6%
e 155745
 
7.3%
r 155745
 
7.3%
w 114386
 
5.3%
5 114386
 
5.3%
( 114386
 
5.3%
) 114386
 
5.3%
m 114386
 
5.3%
a 114386
 
5.3%
Other values (12) 559644
26.2%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 2139071
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
311490
14.6%
o 270131
12.6%
e 155745
 
7.3%
r 155745
 
7.3%
w 114386
 
5.3%
5 114386
 
5.3%
( 114386
 
5.3%
) 114386
 
5.3%
m 114386
 
5.3%
a 114386
 
5.3%
Other values (12) 559644
26.2%

Site Permit
Boolean

CONSTANT  MISSING 

Distinct1
Distinct (%)< 0.1%
Missing193550
Missing (%)97.3%
Memory size388.6 KiB
True
 
5360
(Missing)
193550 
ValueCountFrequency (%)
True 5360
 
2.7%
(Missing) 193550
97.3%
2024-08-30T20:24:44.588667image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Supervisor District
Unsupported

REJECTED  UNSUPPORTED 

Missing1719
Missing (%)0.9%
Memory size7.4 MiB

Neighborhoods - Analysis Boundaries
Categorical

HIGH CORRELATION 

Distinct41
Distinct (%)< 0.1%
Missing1725
Missing (%)0.9%
Memory size13.6 MiB
Financial District/South Beach
21816 
Mission
14682 
Sunset/Parkside
 
10207
West of Twin Peaks
 
8740
Castro/Upper Market
 
8527
Other values (36)
133213 

Length

Max length30
Median length18
Mean length14.780977
Min length6

Characters and Unicode

Total characters2914587
Distinct characters46
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowNob Hill
2nd rowSunset/Parkside
3rd rowBernal Heights
4th rowPacific Heights
5th rowMission

Common Values

ValueCountFrequency (%)
Financial District/South Beach 21816
 
11.0%
Mission 14682
 
7.4%
Sunset/Parkside 10207
 
5.1%
West of Twin Peaks 8740
 
4.4%
Castro/Upper Market 8527
 
4.3%
Pacific Heights 8508
 
4.3%
Marina 8244
 
4.1%
Outer Richmond 7855
 
3.9%
Noe Valley 7844
 
3.9%
South of Market 7573
 
3.8%
Other values (31) 93189
46.8%

Length

2024-08-30T20:24:44.935801image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
beach 25870
 
6.5%
financial 21816
 
5.5%
district/south 21816
 
5.5%
mission 19211
 
4.9%
heights 18661
 
4.7%
of 16313
 
4.1%
market 16100
 
4.1%
hill 15798
 
4.0%
valley 14233
 
3.6%
richmond 12313
 
3.1%
Other values (46) 212950
53.9%

Most occurring characters

ValueCountFrequency (%)
i 281035
 
9.6%
e 234500
 
8.0%
a 203693
 
7.0%
n 198634
 
6.8%
197896
 
6.8%
t 194569
 
6.7%
s 176846
 
6.1%
o 150144
 
5.2%
r 148187
 
5.1%
c 109199
 
3.7%
Other values (36) 1019884
35.0%

Most occurring categories

ValueCountFrequency (%)
(unknown) 2914587
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
i 281035
 
9.6%
e 234500
 
8.0%
a 203693
 
7.0%
n 198634
 
6.8%
197896
 
6.8%
t 194569
 
6.7%
s 176846
 
6.1%
o 150144
 
5.2%
r 148187
 
5.1%
c 109199
 
3.7%
Other values (36) 1019884
35.0%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 2914587
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
i 281035
 
9.6%
e 234500
 
8.0%
a 203693
 
7.0%
n 198634
 
6.8%
197896
 
6.8%
t 194569
 
6.7%
s 176846
 
6.1%
o 150144
 
5.2%
r 148187
 
5.1%
c 109199
 
3.7%
Other values (36) 1019884
35.0%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 2914587
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
i 281035
 
9.6%
e 234500
 
8.0%
a 203693
 
7.0%
n 198634
 
6.8%
197896
 
6.8%
t 194569
 
6.7%
s 176846
 
6.1%
o 150144
 
5.2%
r 148187
 
5.1%
c 109199
 
3.7%
Other values (36) 1019884
35.0%

Zipcode
Real number (ℝ)

HIGH CORRELATION 

Distinct27
Distinct (%)< 0.1%
Missing1716
Missing (%)0.9%
Infinite0
Infinite (%)0.0%
Mean94115.501
Minimum94102
Maximum94158
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 MiB
2024-08-30T20:24:45.316310image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Quantile statistics

Minimum94102
5-th percentile94103
Q194109
median94114
Q394122
95-th percentile94133
Maximum94158
Range56
Interquartile range (IQR)13

Descriptive statistics

Standard deviation9.2701045
Coefficient of variation (CV)9.8497107 × 10-5
Kurtosis1.2263383
Mean94115.501
Median Absolute Deviation (MAD)6
Skewness0.85171252
Sum1.8559012 × 1010
Variance85.934838
MonotonicityNot monotonic
2024-08-30T20:24:45.690939image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
94110 17838
 
9.0%
94114 13404
 
6.7%
94117 11781
 
5.9%
94109 11348
 
5.7%
94103 10988
 
5.5%
94115 10095
 
5.1%
94118 9813
 
4.9%
94123 9515
 
4.8%
94122 8886
 
4.5%
94105 8628
 
4.3%
Other values (17) 84898
42.7%
ValueCountFrequency (%)
94102 7164
3.6%
94103 10988
5.5%
94104 4229
 
2.1%
94105 8628
4.3%
94107 7706
3.9%
94108 5321
 
2.7%
94109 11348
5.7%
94110 17838
9.0%
94111 5385
 
2.7%
94112 7898
4.0%
ValueCountFrequency (%)
94158 1058
 
0.5%
94134 2983
 
1.5%
94133 7424
3.7%
94132 3507
 
1.8%
94131 7665
3.9%
94130 81
 
< 0.1%
94129 23
 
< 0.1%
94127 4993
2.5%
94124 5266
2.6%
94123 9515
4.8%
Distinct57604
Distinct (%)29.2%
Missing1700
Missing (%)0.9%
Memory size18.3 MiB
2024-08-30T20:24:46.465236image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Length

Max length41
Median length40
Mean length40.044278
Min length35

Characters and Unicode

Total characters7897132
Distinct characters16
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique26164 ?
Unique (%)13.3%

Sample

1st row(37.79362102799777, -122.41488237355445)
2nd row(37.759041020475465, -122.50286985467523)
3rd row(37.73778863007536, -122.41197863877355)
4th row(37.78762264983362, -122.43099126735969)
5th row(37.75275550565926, -122.41707462095194)
ValueCountFrequency (%)
37.79226164705184 554
 
0.1%
122.4034859571375 554
 
0.1%
37.79294896659241 330
 
0.1%
122.39809861435491 330
 
0.1%
37.728556952954136 281
 
0.1%
122.47676641508518 281
 
0.1%
37.77523036414975 276
 
0.1%
122.4174703200545 276
 
0.1%
37.78977799888473 252
 
0.1%
122.40173648131338 252
 
0.1%
Other values (115177) 391034
99.1%
2024-08-30T20:24:47.510120image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 899264
11.4%
7 893479
11.3%
3 736584
9.3%
1 703929
8.9%
4 698318
8.8%
5 534319
 
6.8%
6 524243
 
6.6%
8 524195
 
6.6%
9 523487
 
6.6%
0 478844
 
6.1%
Other values (6) 1380470
17.5%

Most occurring categories

ValueCountFrequency (%)
(unknown) 7897132
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
2 899264
11.4%
7 893479
11.3%
3 736584
9.3%
1 703929
8.9%
4 698318
8.8%
5 534319
 
6.8%
6 524243
 
6.6%
8 524195
 
6.6%
9 523487
 
6.6%
0 478844
 
6.1%
Other values (6) 1380470
17.5%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 7897132
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
2 899264
11.4%
7 893479
11.3%
3 736584
9.3%
1 703929
8.9%
4 698318
8.8%
5 534319
 
6.8%
6 524243
 
6.6%
8 524195
 
6.6%
9 523487
 
6.6%
0 478844
 
6.1%
Other values (6) 1380470
17.5%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 7897132
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
2 899264
11.4%
7 893479
11.3%
3 736584
9.3%
1 703929
8.9%
4 698318
8.8%
5 534319
 
6.8%
6 524243
 
6.6%
8 524195
 
6.6%
9 523487
 
6.6%
0 478844
 
6.1%
Other values (6) 1380470
17.5%

Record ID
Real number (ℝ)

Distinct198900
Distinct (%)> 99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.1620463 × 1012
Minimum1.2935322 × 1010
Maximum1.4983421 × 1012
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 MiB
2024-08-30T20:24:47.864533image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Quantile statistics

Minimum1.2935322 × 1010
5-th percentile1.3453409 × 1011
Q11.3085657 × 1012
median1.3718398 × 1012
Q31.434998 × 1012
95-th percentile1.4859048 × 1012
Maximum1.4983421 × 1012
Range1.4854068 × 1012
Interquartile range (IQR)1.2643222 × 1011

Descriptive statistics

Standard deviation4.9182197 × 1011
Coefficient of variation (CV)0.42323786
Kurtosis0.55165918
Mean1.1620463 × 1012
Median Absolute Deviation (MAD)6.3217113 × 1010
Skewness-1.5726861
Sum2.3114262 × 1017
Variance2.4188885 × 1023
MonotonicityNot monotonic
2024-08-30T20:24:48.366011image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1.415850502 × 10122
 
< 0.1%
1.317532663 × 10112
 
< 0.1%
1.448683508 × 10122
 
< 0.1%
1.394751213 × 10122
 
< 0.1%
1.475973855 × 10112
 
< 0.1%
1.301037451 × 10122
 
< 0.1%
1.410003156 × 10122
 
< 0.1%
1.350685167 × 10122
 
< 0.1%
1.344366188 × 10122
 
< 0.1%
1.414026241 × 10122
 
< 0.1%
Other values (198890) 198890
> 99.9%
ValueCountFrequency (%)
1.29353215 × 10101
< 0.1%
1.295722223 × 10101
< 0.1%
1.296226196 × 10101
< 0.1%
1.296342101 × 10101
< 0.1%
1.296629102 × 10101
< 0.1%
1.297286249 × 10101
< 0.1%
1.297668221 × 10101
< 0.1%
1.297846157 × 10101
< 0.1%
1.298230162 × 10101
< 0.1%
1.298784182 × 10101
< 0.1%
ValueCountFrequency (%)
1.498342128 × 10121
< 0.1%
1.498341156 × 10121
< 0.1%
1.498339194 × 10121
< 0.1%
1.498338347 × 10121
< 0.1%
1.498337117 × 10121
< 0.1%
1.498336196 × 10121
< 0.1%
1.498335409 × 10121
< 0.1%
1.498334222 × 10121
< 0.1%
1.498331399 × 10121
< 0.1%
1.498330476 × 10121
< 0.1%

Interactions

2024-08-30T20:23:42.666073image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:34.453785image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:39.904770image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:45.174668image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:50.806294image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:56.159817image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:01.583409image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:06.995523image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:12.453158image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:17.751881image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:23.213172image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:28.179614image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:33.701298image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:43.329189image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:34.845375image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:40.320341image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:45.510138image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:51.196946image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:56.570170image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:01.986195image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:07.426655image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:12.895032image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:18.168115image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:23.582639image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:28.642964image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:35.342870image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:43.785703image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:35.205898image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:40.623274image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:45.920588image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:51.525510image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:56.891058image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:02.306926image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:07.744258image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:13.228820image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:18.638315image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:23.887233image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:29.061211image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:35.666884image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:44.407410image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:35.595690image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:40.987059image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:46.231921image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:51.895175image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:57.309255image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:02.683378image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:08.279165image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:13.593819image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:19.040753image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:24.299056image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:29.440817image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:36.049444image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:45.051488image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:35.994022image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:41.386693image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:46.584551image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:52.297621image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:57.738228image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:03.108640image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:08.698328image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:14.059680image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:19.459181image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:24.678313image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:29.856587image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:36.449039image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:45.725049image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:36.424933image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:41.774751image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:46.902970image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:52.709910image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:58.255387image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:03.509420image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:09.125991image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:14.505524image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:19.865361image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:25.127789image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:30.293530image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:36.841341image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:46.449130image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:36.794591image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:42.144431image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:47.254623image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:53.142863image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:58.637374image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:03.863880image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:09.542197image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:14.880852image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:20.353053image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:25.477542image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:30.726428image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:37.248234image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:47.102870image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:37.336681image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:42.576904image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:47.676174image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:53.525746image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:59.071401image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:04.281847image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:09.926233image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:15.281608image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:20.731193image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:25.860462image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:31.138695image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:37.665486image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:47.757553image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:37.743767image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:42.969866image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:47.987249image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:53.959625image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:59.502138image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:04.998908image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:10.313016image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:15.682674image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:21.155068image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:26.260133image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:31.571548image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:38.528916image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:48.360339image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:38.159183image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:43.515427image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:48.328789image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:54.458765image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:59.902868image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:05.430671image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:10.724391image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:16.113781image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:21.579078image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:26.662530image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:32.023048image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:39.825439image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:48.861325image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:38.589519image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:43.923581image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:48.682704image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:54.810185image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:00.303870image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:05.780931image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:11.099003image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:16.486416image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:21.930997image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:26.999798image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:32.404090image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:40.556778image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:49.376149image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:39.023467image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:44.443928image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:49.013978image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:55.259396image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:00.750989image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:06.213397image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:11.509032image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:16.935965image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:22.363925image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:27.410020image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:32.826365image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:41.321255image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:49.988671image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:39.508378image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:44.816623image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:50.412762image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:22:55.725657image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:01.151007image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:06.600725image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:11.923196image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:17.352254image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:22.763569image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:27.778413image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:33.270830image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-08-30T20:23:42.024343image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Correlations

2024-08-30T20:24:48.745378image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Current StatusEstimated CostExisting Construction TypeExisting Construction Type DescriptionExisting UnitsNeighborhoods - Analysis BoundariesNumber of Existing StoriesNumber of Proposed StoriesPermit TypePermit Type DefinitionPlansetsProposed Construction TypeProposed Construction Type DescriptionProposed UnitsRecord IDRevised CostStreet NumberStreet Number SuffixStreet SuffixUnitZipcode
Current Status1.0000.0150.0000.0280.0000.0390.0230.0230.1350.1030.0000.0320.0320.0020.1060.0150.0180.1730.0260.0000.027
Estimated Cost0.0151.000-0.0730.0000.0090.0090.0990.117-0.2080.1490.2590.0210.0210.0080.0250.884-0.0200.0000.0000.006-0.030
Existing Construction Type0.000-0.0731.0000.0000.2630.000-0.620-0.6240.0060.000-0.3460.0000.0000.2520.091-0.0810.2211.0000.000-0.1450.487
Existing Construction Type Description0.0280.0000.0001.0000.1150.3260.3070.3110.0700.4010.0000.9940.9940.1150.0850.0000.0940.0730.1110.1180.248
Existing Units0.0000.0090.2630.1151.0000.1310.1850.1680.0050.007-0.1690.1420.1420.9810.052-0.0040.1670.0000.0630.4380.049
Neighborhoods - Analysis Boundaries0.0390.0090.0000.3260.1311.0000.2750.2780.0930.0710.0000.4260.4260.1320.3680.0080.3220.2240.2110.1200.770
Number of Existing Stories0.0230.099-0.6200.3070.1850.2751.0000.9820.0250.0300.2860.4100.4100.181-0.1090.099-0.1330.0790.0920.197-0.411
Number of Proposed Stories0.0230.117-0.6240.3110.1680.2780.9821.000-0.0210.0310.3110.4090.4090.194-0.1060.110-0.1280.0680.0920.196-0.413
Permit Type0.135-0.2080.0060.0700.0050.0930.025-0.0211.0001.000-0.2850.0570.057-0.069-0.013-0.243-0.0050.2040.0580.0640.001
Permit Type Definition0.1030.1490.0000.4010.0070.0710.0300.0311.0001.0000.0000.0490.0490.0150.0230.1620.0150.2040.0440.0000.043
Plansets0.0000.259-0.3460.000-0.1690.0000.2860.311-0.2850.0001.0000.0000.000-0.133-0.0150.233-0.0641.0000.000-0.189-0.204
Proposed Construction Type0.0320.0210.0000.9940.1420.4260.4100.4090.0570.0490.0001.0001.0000.1430.0850.0170.1210.0540.1480.1330.306
Proposed Construction Type Description0.0320.0210.0000.9940.1420.4260.4100.4090.0570.0490.0001.0001.0000.1430.0850.0170.1210.0540.1480.1330.306
Proposed Units0.0020.0080.2520.1150.9810.1320.1810.194-0.0690.015-0.1330.1430.1431.0000.053-0.0070.1680.0000.0640.4370.029
Record ID0.1060.0250.0910.0850.0520.368-0.109-0.106-0.0130.023-0.0150.0850.0850.0531.000-0.015-0.0230.2840.094-0.230-0.003
Revised Cost0.0150.884-0.0810.000-0.0040.0080.0990.110-0.2430.1620.2330.0170.017-0.007-0.0151.000-0.0630.0000.0000.024-0.029
Street Number0.018-0.0200.2210.0940.1670.322-0.133-0.128-0.0050.015-0.0640.1210.1210.168-0.023-0.0631.0000.1040.119-0.0050.151
Street Number Suffix0.1730.0001.0000.0730.0000.2240.0790.0680.2040.2041.0000.0540.0540.0000.2840.0000.1041.0000.0780.0000.195
Street Suffix0.0260.0000.0000.1110.0630.2110.0920.0920.0580.0440.0000.1480.1480.0640.0940.0000.1190.0781.0000.0790.247
Unit0.0000.006-0.1450.1180.4380.1200.1970.1960.0640.000-0.1890.1330.1330.437-0.2300.024-0.0050.0000.0791.000-0.060
Zipcode0.027-0.0300.4870.2480.0490.770-0.411-0.4130.0010.043-0.2040.3060.3060.029-0.003-0.0290.1510.1950.247-0.0601.000

Missing values

2024-08-30T20:23:51.826031image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-08-30T20:23:54.671218image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
2024-08-30T20:23:59.199777image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

Permit NumberPermit TypePermit Type DefinitionPermit Creation DateBlockLotStreet NumberStreet Number SuffixStreet NameStreet SuffixUnitUnit SuffixDescriptionCurrent StatusCurrent Status DateFiled DateIssued DateCompleted DateFirst Construction Document DateStructural NotificationNumber of Existing StoriesNumber of Proposed StoriesVoluntary Soft-Story RetrofitFire Only PermitPermit Expiration DateEstimated CostRevised CostExisting UseExisting UnitsProposed UseProposed UnitsPlansetsTIDF ComplianceExisting Construction TypeExisting Construction Type DescriptionProposed Construction TypeProposed Construction Type DescriptionSite PermitSupervisor DistrictNeighborhoods - Analysis BoundariesZipcodeLocationRecord ID
0M7889278otc alterations permit05/23/201702150011333NaNjOnEsStNaNNaNstreet spaceissued05/23/201705/23/201705/23/2017NaN05/23/2017NaNNaNNaNNaNNaNNaNNaN1.00NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN3.0Nob Hill94109.00(37.79362102799777, -122.41488237355445)1464153232862
12013053183568otc alterations permit05/31/20131810017A1483NaN43rDAvNaNNaNremodel kitchen: replace countertop, cabinets, sink, stove, hardwood floor & lighting.complete08/28/201305/31/201306/03/201308/28/201306/03/2013NaN2.002.00NaNNaN05/29/201412000.0012000.001 family dwelling1.001 family dwelling1.002.00NaN5.00wood frame (5)5.00wood frame (5)NaN4.0Sunset/Parkside94122.00(37.759041020475465, -122.50286985467523)1306559115258
22017051062058otc alterations permit05/10/20175700027431NaNpReNtIsSStNaNNaNreplacement of 4 windows; 2 located in lightwell and 2 at front. replaceing existing vinyl windows with new wood-clad windows. no horizontal mullion in living room windowissued05/11/201705/10/201705/11/2017NaN05/11/2017NaN2.002.00NaNNaN05/06/20181000.002000.001 family dwelling1.001 family dwelling1.000.00NaN5.00wood frame (5)5.00wood frame (5)NaN9.0Bernal Heights94110.00(37.73778863007536, -122.41197863877355)1462579187173
32014102799838otc alterations permit10/27/201406610052020NaNbUsHStNaNNaNtwo kitchens & two bathrooms remodel. replace kitchen cabinets, countertops & appliances in same location. replace tub & faucet & vanity & tile in same location in both units.complete12/31/201410/27/201410/27/201412/31/201410/27/2014NaN2.002.00NaNNaN10/22/201535000.0035000.002 family dwelling2.002 family dwelling2.000.00NaN5.00wood frame (5)5.00wood frame (5)NaN5.0Pacific Heights94115.00(37.78762264983362, -122.43099126735969)136037778128
42013102803888otc alterations permit10/28/20133642051A871NaNcApPStNaNNaNreroofingissued10/28/201310/28/201310/28/2013NaN10/28/2013NaN2.002.00NaNNaN10/23/20149900.009900.00apartments4.00apartments4.000.00NaN5.00wood frame (5)5.00wood frame (5)NaN9.0Mission94110.00(37.75275550565926, -122.41707462095194)1322242163712
52013071619258otc alterations permit07/16/201335650763479NaN16tHStNaNNaNto comply with physical inspection report #cc-7260 item #1 -all storage items are being removed.complete10/08/201307/16/201307/16/201310/08/201307/16/2013NaN3.003.00NaNNaN07/11/20147500.007500.00apartments3.00apartments3.000.00NaN5.00wood frame (5)5.00wood frame (5)NaN8.0Castro/Upper Market94114.00(37.76416871595274, -122.43039745629406)1311167285194
6M5016078otc alterations permit07/02/20143561007238NaNnOeStNaNNaNstreet spaceissued07/02/201407/02/201407/02/2014NaN07/02/2014NaNNaNNaNNaNNaNNaNNaN1.00NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN8.0Castro/Upper Market94114.00(37.76519640087225, -122.4334386869886)1347642247334
7M7878878otc alterations permit05/19/201706540092338NaNpInEStNaNNaNstreet space permitissued05/19/201705/19/201705/19/2017NaN05/19/2017NaNNaNNaNNaNNaNNaNNaN1.00NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN2.0Pacific Heights94115.00(37.78814050763782, -122.43440743226256)1463876236318
82014041130258otc alterations permit04/11/20143740029126NaNfOlSoMStNaNNaNexisting office and storage facility. new partitions, restroom upgrade. electrical on a separate permitcomplete10/02/201404/11/201404/25/201410/02/201404/25/2014NaN1.001.00NaNNaN04/09/2017125000.00125000.00officeNaNofficeNaN2.00NaN3.00constr type 33.00constr type 3NaN6.0Financial District/South Beach94105.00(37.78992343288329, -122.3915399961996)1338371165676
92017021091348otc alterations permit02/10/20170195001735NaNmOnTgOmErYStNaNNaNbasement & 1/f- as built drawing for fire/smoke damper on hvac duct (existing) under pa#201612074341. n/a ordinance #155-13complete03/09/201702/10/201702/10/201703/09/201702/10/2017NaN4.004.00NaNNaN02/05/20181.001.00retail sales0.00retail sales0.002.00NaN3.00constr type 33.00constr type 3NaN3.0Chinatown94111.00(37.79621627942539, -122.40375479881872)145294162223
Permit NumberPermit TypePermit Type DefinitionPermit Creation DateBlockLotStreet NumberStreet Number SuffixStreet NameStreet SuffixUnitUnit SuffixDescriptionCurrent StatusCurrent Status DateFiled DateIssued DateCompleted DateFirst Construction Document DateStructural NotificationNumber of Existing StoriesNumber of Proposed StoriesVoluntary Soft-Story RetrofitFire Only PermitPermit Expiration DateEstimated CostRevised CostExisting UseExisting UnitsProposed UseProposed UnitsPlansetsTIDF ComplianceExisting Construction TypeExisting Construction Type DescriptionProposed Construction TypeProposed Construction Type DescriptionSite PermitSupervisor DistrictNeighborhoods - Analysis BoundariesZipcodeLocationRecord ID
1989002015060277678otc alterations permit06/02/20157101A007736NaNhUrOnAvNaNNaNreroofingcomplete03/11/201606/02/201506/02/201503/11/201606/02/2015NaN2.002.00NaNNaN05/27/20166000.006000.001 family dwelling1.001 family dwelling1.000.00NaN5.00wood frame (5)5.00wood frame (5)NaN11.00Outer Mission94112.00(37.71192805393076, -122.4500944316179)1383549221502
198901M8710278otc alterations permit12/28/201718700231514NaN25tHAvNaNNaNstreet spaceissued12/28/201712/28/201712/28/2017NaN12/28/2017NaNNaNNaNNaNNaNNaNNaN1.00NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN4.00Sunset/Parkside94122.00(37.75921574765919, -122.48300451049278)1492023118112
1989022016092081758otc alterations permit09/20/20162130A006G78NaNcRaGmOnTAvNaNNaNreplace (e) tub with walk in tub, 20 amp circuit, gfci outletcomplete09/28/201609/20/201609/20/201609/28/201609/20/2016NaN2.002.00NaNNaN09/15/201717900.0017900.001 family dwelling1.001 family dwelling1.000.00NaN5.00wood frame (5)5.00wood frame (5)NaN7.00Inner Sunset94116.00(37.74973733662819, -122.4671301493082)1438114126978
1989032014071614168otc alterations permit07/16/2014252802466NaNcReStLaKeDrNaNNaNcut a door and a staircase for access to backyard.build deck next to staircase.complete01/23/201507/16/201410/28/201401/23/201510/28/2014Y2.002.00NaNNaN10/23/20154500.006000.001 family dwelling1.001 family dwelling1.002.00NaN5.00wood frame (5)5.00wood frame (5)NaN4.00Sunset/Parkside94132.00(37.73542953855242, -122.48149902038024)1349089138746
198904M6510478otc alterations permit12/30/20156176008342NaNhArKnEsSAvNaNNaNstreet spaceissued12/30/201512/30/201512/30/2015NaN12/30/2015NaNNaNNaNNaNNaNNaNNaN0.00NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN10.00Visitacion Valley94134.00(37.71765127619624, -122.40342209330782)1407979197645
1989052016040539583additions alterations or repairs04/05/201672950213251NaN20tHAvNaNNaNti for space 129,130, 132 partitions, mep, shelving, stonestown mall. ab -56 compliance 2014-0627-9771complete11/22/201604/05/201607/18/201611/22/201607/18/2016NaN2.002.00NaNNaN07/03/2019325000.00928009.20retail sales0.00retail sales0.002.00NaN2.00constr type 22.00constr type 2NaN7.00Lakeshore94132.00(37.728556952954136, -122.47676641508518)1418495226171
1989062015102708808otc alterations permit10/27/20154009001A1919NaNmArIpOsAStNaNNaNinstall new 2" underground combination fire main. ref app#201402108156issued10/27/201510/27/201510/27/2015NaN10/27/2015NaN3.003.00NaNY10/21/20161200.009600.001 family dwelling1.001 family dwelling1.002.00NaN5.00wood frame (5)5.00wood frame (5)NaN10.00Potrero Hill94107.00(37.76328445631136, -122.40287014554292)1400885168656
1989072016072937418otc alterations permit07/29/201642620201341NaNsAn bRuNoAvNaNNaNreplace rotten wooden moldings in kind front stairs less than 50% replaceissued07/29/201607/29/201607/29/2016NaN07/29/2016NaN2.002.00NaNNaN07/24/20171900.001900.001 family dwelling1.001 family dwelling1.000.00NaN5.00wood frame (5)5.00wood frame (5)NaN10.00Mission94110.00(37.75260530951628, -122.40400191084352)1431897172643
1989082017010666918otc alterations permit01/06/20170146007660NaNbRoAdWaYNaNNaNNaNrevision to pa 2016-0926-8773; remove (e) storefront & doors, remove floor, ceiling & wall finishes for new. new storefront, (n) wall & ceiling finishes, (n) flooring with waterproofing in a (n) alcove. mep under pa#201503100377issued02/01/201701/06/201702/01/2017NaN02/01/2017NaN2.002.00NaNNaN01/27/20181.001.00retail sales9.00retail sales9.002.00NaN5.00wood frame (5)5.00wood frame (5)NaN3.00Chinatown94133.00(37.79800446861674, -122.4080339831039)1449660232064
1989092016042555998otc alterations permit04/25/20163708056525NaNmArKeTStNaNNaN16th floor - (4) evacuation plans.issued04/25/201604/25/201604/25/2016NaN04/25/2016NaN38.0038.00NaNY04/20/20171600.001600.00office0.00office0.002.00NaN1.00constr type 11.00constr type 1NaN6.00Financial District/South Beach94105.00(37.79040639954478, -122.39927546096968)1420790164534